[dbo].[Exhb_Srvc

Property	Value
Heap
Row Count	2
Created	3:12:20 PM Friday, January 07, 2011
Last Modified	11:40:02 AM Monday, February 20, 2012

Property

Value

Heap

Row Count

Created

3:12:20 PM Friday, January 07, 2011

Last Modified

11:40:02 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
$Indexes iExhb_Srvc_CompCLUSTERMEC: MEET_ID\EXHB_ID\CONT_ID$	MEET_ID	varchar(10)	10
$Indexes iExhb_Srvc_CompCLUSTERMEC: MEET_ID\EXHB_ID\CONT_ID$	EXHB_ID	varchar(10)	10
$Indexes iExhb_Srvc_CompCLUSTERMEC: MEET_ID\EXHB_ID\CONT_ID$	CONT_ID	varchar(10)	10
	INSUR_DATE	datetime	8
	INSURANCE	bit	1	((0))
	CONTACT_NAME	varchar(40)	40
	CONTACT_PHONE	varchar(20)	20
	TIME_STAMP	timestamp	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Indexes iExhb_Srvc_CompCLUSTERMEC: MEET_ID\EXHB_ID\CONT_ID$

MEET_ID

varchar(10)

$Indexes iExhb_Srvc_CompCLUSTERMEC: MEET_ID\EXHB_ID\CONT_ID$

EXHB_ID

varchar(10)

$Indexes iExhb_Srvc_CompCLUSTERMEC: MEET_ID\EXHB_ID\CONT_ID$

CONT_ID

varchar(10)

INSUR_DATE

datetime

INSURANCE

bit

((0))

CONTACT_NAME

varchar(40)

CONTACT_PHONE

varchar(20)

TIME_STAMP

timestamp

Name	Columns
iExhb_Srvc_CompCLUSTERMEC	MEET_ID, EXHB_ID, CONT_ID

Name

Columns

iExhb_Srvc_CompCLUSTERMEC

MEET_ID, EXHB_ID, CONT_ID

Type	Action	Owning Principal
Grant	Delete	IMIS
Grant	Insert	IMIS
Grant	References	IMIS
Grant	Select	IMIS
Grant	Update	IMIS

Type

Action

Owning Principal

Grant

Delete

IMIS

Grant

Insert

IMIS

Grant

References

IMIS

Grant

Select

IMIS

Grant

Update

IMIS

SQL Script

CREATE TABLE [dbo].[Exhb_Srvc_Comp]
(
[MEET_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EXHB_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONT_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INSUR_DATE] [datetime] NULL,
[INSURANCE] [bit] NOT NULL CONSTRAINT [DF_Exhb_Srvc_Comp_INSURANCE] DEFAULT ((0)),
[CONTACT_NAME] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONTACT_PHONE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iExhb_Srvc_CompCLUSTERMEC] ON [dbo].[Exhb_Srvc_Comp] ([MEET_ID], [EXHB_ID], [CONT_ID]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Exhb_Srvc_Comp] TO [IMIS]
GRANT SELECT ON  [dbo].[Exhb_Srvc_Comp] TO [IMIS]
GRANT INSERT ON  [dbo].[Exhb_Srvc_Comp] TO [IMIS]
GRANT DELETE ON  [dbo].[Exhb_Srvc_Comp] TO [IMIS]
GRANT UPDATE ON  [dbo].[Exhb_Srvc_Comp] TO [IMIS]
GO